package cn.crex1.xiaomi.dao;

import java.util.List;

import cn.crex1.xiaomi.core.orm.annotion.Query;
import cn.crex1.xiaomi.core.orm.annotion.ResultType;
import cn.crex1.xiaomi.vo.ProductVO;
/**
 * 搜索框，模糊查询
 * @author sunzhong
 *
 */
public interface SearchDao {
	
	//模糊查询  select os_product.product_number,os_product.`name`,os_product.show_price,os_product.introduce,os_product.pic_img from os_product where os_product.`name`  like '%2%';
	@Query(sql="select os_product.product_number,os_product.`name`,os_product.show_price,os_product.introduce,os_product.pic_img from os_product where ? like '%$%' ")
	@ResultType(value="List")//定义返回值
	List<ProductVO> selectOProductByOProductName(ProductVO productVO);

}
